﻿using SqlSugar;

namespace Api.Shared.Model
{
    public class DB91WorkorderSqlite
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int Id { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string WorkOrder { get; set; } = string.Empty;

        /// <summary>
        /// 图号
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string Pic { get; set; } = string.Empty;

        /// <summary>
        /// 名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string Name { get; set; } = string.Empty;

        /// <summary>
        /// 数量
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public short Num { get; set; }

        /// <summary>
        /// 工单号简化
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public short WorkOrderNum { get; set; }


        /// <summary>
        /// 图号简化
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public short PicNum { get; set; }

        /// <summary>
        /// 图号简化
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public System.DateTime Time { get; set; } = System.DateTime.Now;

        [SugarColumn(IsNullable = true)]
        public string TimeStr { get; set; } = System.DateTime.Now.ToShortDateString();

        [SugarColumn(IsNullable = true)]
        public string? Comment1 { get; set; } = string.Empty;

        [SugarColumn(IsNullable = true)]
        public string? Comment2 { get; set; } = string.Empty;

        [SugarColumn(IsNullable = true)]
        public string? Comment3 { get; set; } = string.Empty;
    }
}
